package com.cwt_taxi_xa.db.dal;

/**
 * 数据库常量类
 * @author wlh
 *
 */
public class DBConstants {

	/** 数据表名*/
	public static final String TABLE_LOCATION_INFO = "location";
	public static final String TABLE_OPERATION_DATA = "operation";

	public static final String LOCATION_INFO_ID = "id";
	public static final String LOCATION_INFO_ORDER_ID = "orderid";
	public static final String LOCATION_INFO_DATA = "data";

	/** 招标信息*/
	public static final String TABLE_INVITATION = "invitation";
	public static final String INVITATION_ID = "id";
	public static final String INVITATION_ORDER_ID = "orderid";
	public static final String INVITATION_MESSAGE = "message";
	public static final String INVITATION_CREATE_TIME = "create_time";
	public static final String INVITATION_ORDER_TYPE = "type";
	public static final String INVITATION_ORDER_TIME = "order_time";
	/*public static final String INVITATION_STARTING = "starting";
	public static final String INVITATION_DESTINATION = "destination";*/
	public static final String INVITATION_REMARK = "remark";
	public static final String INVITATION_STATUS = "status";
	//	public static final String INVITATION_ANSWER_TYPE = "answertype";
	//	public static final String INVITATION_PHONE = "phone";
	//	public static final String INVITATION_RANGE = "range";
	//	public static final String INVITATION_BEGIN_LON = "beginlon";
	//	public static final String INVITATION_BEGIN_LAT = "beginlat";
	//	public static final String INVITATION_END_LON= "endlon";
	//	public static final String INVITATION_END_LAT = "endlat";
	//	public static final String INVITATION_URL = "url";
	//	public static final String INVITATION_PASSENGER_NAME = "pasenger_name";

	/** 中标信息*/
	public static final String TABLE_SUCCESSFUL_BIDDER = "successful_bidder";
	public static final String SB_ID = "id";
	public static final String SB_STATUS = "status";
	public static final String SB_ORDER_ID = "orderid";
	public static final String SB_PASSENGER_PHONE = "passenger_phone";
	public static final String SB_MESSAGE = "message";
	public static final String SB_IS_DONE = "isdone";
	public static final String SB_CREATE_TIME = "create_time";
	public static final String SB_IS_PUSH = "ispush";
	public static final String SB_ORDER_TYPE = "type";
	public static final String SB_ORDER_TIME = "order_time";
	public static final String SB_REMARK = "remark";
	public static final String ORDER_LNG_START = "lng_start";
	public static final String ORDER_LAT_START = "lat_start";
	public static final String ORDER_LNG_END = "lng_end";
	public static final String ORDER_LAT_END = "lat_end";
	//	public static final String SB_CAR_NUMBER = "carnumber";
	public static final String SB_FEE = "fee";
	public static final String SB_DO_STATUS = "dostatus";
	//	public static final String SB_LOCAL_NUMBER = "local_number";
	//	public static final String SB_LON = "lon";
	//	public static final String SB_LAT = "lat";
	//	public static final String SB_URL = "url";
	//	public static final String SB_ORDER_SOURCE = "source";
	//	public static final String SB_PASSENGER_NAME = "pasenger_name";

	/** 乘客信息*/
	public static final String TABLE_PASSENGER_INFO = "passenger";
	public static final String PASSENGER_INFO_ID = "id";	// id
	public static final String PASSENGER_INFO_PHONE_NUMBER = "phonenumber";	// 联系号码
	public static final String PASSENGER_INFO_RECORD_TIME = "recordtime";	// 收录时间

	/** 月流量信息*/
	public static final String TABLE_FLOW_MONTH = "flow_month";
	public static final String FLOW_PKG_NAME = "pkgname";
	public static final String PKG_YEAR = "year";
	public static final String PKG_GPRS = "gprs";
	public static final String FLOW_DAY = "day";
	public static final String FLOW_DAY_1 = "day1";
	public static final String FLOW_DAY_2 = "day2";
	public static final String FLOW_DAY_3 = "day3";
	public static final String FLOW_DAY_4 = "day4";
	public static final String FLOW_DAY_5 = "day5";
	public static final String FLOW_DAY_6 = "day6";
	public static final String FLOW_DAY_7 = "day7";
	public static final String FLOW_DAY_8 = "day8";
	public static final String FLOW_DAY_9 = "day9";
	public static final String FLOW_DAY_10 = "day10";
	public static final String FLOW_DAY_11 = "day11";
	public static final String FLOW_DAY_12 = "day12";
	public static final String FLOW_DAY_13 = "day13";
	public static final String FLOW_DAY_14 = "day14";
	public static final String FLOW_DAY_15 = "day15";
	public static final String FLOW_DAY_16 = "day16";
	public static final String FLOW_DAY_17 = "day17";
	public static final String FLOW_DAY_18 = "day18";
	public static final String FLOW_DAY_19 = "day19";
	public static final String FLOW_DAY_20 = "day20";
	public static final String FLOW_DAY_21 = "day21";
	public static final String FLOW_DAY_22 = "day22";
	public static final String FLOW_DAY_23 = "day23";
	public static final String FLOW_DAY_24 = "day24";
	public static final String FLOW_DAY_25 = "day25";
	public static final String FLOW_DAY_26 = "day26";
	public static final String FLOW_DAY_27 = "day27";
	public static final String FLOW_DAY_28 = "day28";
	public static final String FLOW_DAY_29 = "day29";
	public static final String FLOW_DAY_30 = "day30";
	public static final String FLOW_DAY_31 = "day31";

	/** 围栏信息*/
	public static final String TABLE_FENCE = "fence_area";
	public static final String FENCE_ID = "id";
	public static final String FENCE_TYPE = "fenceType";
	public static final String FENCE_AREA_ID = "areaId";
	public static final String FENCE_AREA_ATTRB = "areaAttribute";
	public static final String FENCE_START_TIME = "startTime";
	public static final String FENCE_END_TIME = "endTime";
	public static final String FENCE_MAX_SPEED = "maxSpeed";
	public static final String FENCE_TIME_LENGTH = "timeLength";
	public static final String FENCE_TOP_LIGHT_MSG = "topLightMessage";
	public static final String FENCE_DRIVER_MESSAGE = "driverMessage";
	public static final String FENCE_CENTRE_LNG = "centreLng";
	public static final String FENCE_CENTRE_LAT= "centreLat";
	public static final String FENCE_RADIUS = "radius";
	public static final String FENCE_LEFT_TOP_LAT = "leftTopLat";
	public static final String FENCE_LEFT_TOP_LNG = "leftTopLng";
	public static final String FENCE_RIGHT_BOTTOM_LAT = "rightBottomLat";
	public static final String FENCE_RIGHT_BOTTOM_LNG = "rightBottomLng";

	/** 联系人信息*/
	public static final String TABLE_CONTACTS = "contacts";
	public static final String CONTACTS_ID = "id";
	public static final String CONTACTS_TYPE = "type";
	public static final String CONTACTS_NAME = "name";
	public static final String CONTACTS_PHONE = "phone";

	/** 事件*/
	public static final String TABLE_EVENT = "event";
	public static final String EVENT_ID = "id";
	public static final String EVENT_IS_DONE = "isDone";
	public static final String EVENT_IS_READ = "isRead";
	public static final String EVENT_TEXT = "text";
	public static final String EVENT_CREATE_TIME = "creatTime";

	/** 提问*/
	public static final String TABLE_QUESTION = "question";
	public static final String QUESTION_ID = "id";
	public static final String QUESTION_IS_READ = "isRead";
	public static final String QUESTION_IS_DONE = "isDone";
	public static final String QUESTION_TEXT = "text";
	public static final String QUESTION_FLAG = "flag";
	public static final String QUESTION_CREATE_TIME = "creatTime";
	public static final String QUESTION_ANSWER= "answer";
	public static final String QUESTION_ANSWER_ID= "answerId";
	public static final String QUESTION_SERIAL_ID= "serial";

	/** 文本信息*/
	public static final String TABLE_MESSAGE = "message";
	public static final String MESSAGE_ID = "id";
	public static final String MESSAGE_IS_READ = "isread";
	public static final String MESSAGE_CREATE_TIME = "create_time";
	public static final String MESSAGE_CONTENT = "content";
	//	public static final String MESSAGE_TIME_LENGTH = "timeLength";
	//	public static final String MESSAGE_FLAG = "flag";
	//	public static final String MESSAGE_SERIAL = "serail";
	//	public static final String MESSAGE_TTS = "tts";

	/** 照片信息*/
	public static final String TABLE_PHOTO = "photo";
	public static final String PHOTO_ID = "id";
	public static final String PHOTO_TIME = "time";
	public static final String PHOTO_MEDIA_ID = "media_id";
	public static final String PHOTO_SERIAL_ID = "serial_id";
	public static final String PHOTO_EVENT_CODE = "event_code";
	public static final String PHOTO_CHANNEL_ID = "channel_id";
	public static final String PHOTO_RESOLUTION = "resolution";
	public static final String PHOTO_LOCATION_INFO = "location_info";
	public static final String PHOTO_LAT = "lat";
	public static final String PHOTO_LNG = "lng";

	/** 录音信息*/
	public static final String TABLE_RECORDING = "recording";
	public static final String REC_ID = "id";
	public static final String REC_TIME = "time";
	public static final String REC_END_TIME = "end_time";
	public static final String REC_REASON = "reason";
	public static final String REC_MEDIA_ID = "media_id";
	public static final String REC_START_LAT = "start_lat";
	public static final String REC_START_LNG = "start_lng";
	public static final String REC_END_LAT = "end_lat";
	public static final String REC_END_LNG = "end_lng";

	/** 司机信息*/
	public static final String TABLE_DRIVER = "driver_info";// 北京地标表名
	public static final String DRIVER_ID = "id";
	public static final String DRIVER_NAME = "name";
	public static final String DRIVER_COMPANY_NAME = "companyName";
	public static final String DRIVER_COMPANY = "company";
	public static final String DRIVER_TAXI_STAR = "taxi_star";
	public static final String DRIVER_CARD_CODE = "card_code";
	public static final String DRIVER_CERTIFICATE_CODE = "certificate_code";
	public static final String DRIVER_VALIDITY_DATE = "validity_date";
	public static final String DRIVER_CAR_NUMBER = "car_number";
	public static final String DRIVER_NEXT_MEETING_TIME = "next_meeting_time";
	public static final String DRIVER_SERVICE_TEL = "service_tel";
	public static final String DRIVER_IC_CLASS = "ic_class";
	public static final String DRIVER_BLACK_INFO = "black_info";

	/** 金融数据*/
	/*public static final String TABLE_BUSINESS = "business";
	public static final String BUSINESS_ID = "id";
	//	public static final String BUSINESS_MSG_ID = "msg_id";
	//	public static final String BUSINESS_DATA = "data";
	public static final String BUSINESS_STATUS = "status";
	public static final String BUSINESS_CACHE_TYPE = "type";
	public static final String BUSINESS_MESSAGE = "message";*/

	/** 金融缓存数据*/
	/*public static final String TABLE_BUSINESS_CACHE = "business_cache";
	public static final String BUSINESS_CACHE_ID = "id";
	public static final String BUSINESS_CACHE_DATA = "data";
	public static final String BUSINESS_CACHE_TYPE = "type";*/

	/** 本地数据*/
	public static final String TABLE_LOCAL = "local_info";// 北京地标表名
	public static final String LOCAL_ID = "id";
	public static final String LOCAL_DATA = "data";
	public static final String LOCAL_TYPE = "type";
	public static final String LOCAL_STATUS = "status";
	public static final String LOCAL_TIME = "time";
	public static final String LOCAL_DATE = "date";
	public static final String LOCAL_METER_CODE = "meter_code";// 营运数据的计价器号 / 下班签退的开机时间
	public static final String LOCAL_CAR_TIMES = "car_times";// 营运数据的车次 / 下班签退的关机时间
}
